﻿using System.Collections.Generic;

namespace Citi.FinancePlanningAnalysis.Domain
{
    public class Pearl
    {
        #region Mappings

        public static readonly Dictionary<string, string> ExcelColumnMappings = new Dictionary<string, string> { 
                    {"[Nat Sign Jan USD Amount]","NatSigJanAmount"},	
                    {"[Nat Sign Feb USD Amount]","NatSignFebAmount"},	
                    {"[Nat Sign Mar USD Amount]","NatSignMarAmount"},	
                    {"[Nat Sign Apr USD Amount]","NatSignAprAmount"},	
                    {"[Nat Sign May USD Amount]","NatSignMayAmount"},	
                    {"[Nat Sign Jun USD Amount]","NatSignJunAmount"},	
                    {"[Nat Sign Jul USD Amount]","NatSignJulAmount"},	
                    {"[Nat Sign Aug USD Amount]","NatSignAugAmount"},	
                    {"[Nat Sign Sep USD Amount]","NatSignSepAmount"},	
                    {"[Nat Sign Oct USD Amount]","NatSignOctAmount"},	
                    {"[Nat Sign Nov USD Amount]","NatSignNovAmount"},	
                    {"[Nat Sign Dec USD Amount]","NatSignDecAmount"},	
                    {"[Current Year Jan Constant Dollar Amount]","CurrentYearJanConstantAmount"},	
                    {"[Current Year Feb Constant Dollar Amount]","CurrentYearFebConstantAmount"},	
                    {"[Current Year Mar Constant Dollar Amount]","CurrentYearMarConstantAmount"},	
                    {"[Current Year Apr Constant Dollar Amount]","CurrentYearAprConstantAmount"},	
                    {"[Current Year May Constant Dollar Amount]","CurrentYearMayConstantAmount"},	
                    {"[Current Year Jun Constant Dollar Amount]","CurrentYearJunConstantAmount"},	
                    {"[Current Year Jul Constant Dollar Amount]","CurrentYearJulConstantAmount"},	
                    {"[Current Year Aug Constant Dollar Amount]","CurrentYearAugConstantAmount"},	
                    {"[Current Year Sep Constant Dollar Amount]","CurrentYearSepConstantAmount"},	
                    {"[Current Year Oct Constant Dollar Amount]","CurrentYearOctConstantAmount"},	
                    {"[Current Year Nov Constant Dollar Amount]","CurrentYearNovConstantAmount"},	
                    {"[Current Year Dec Constant Dollar Amount]","CurrentYearDecConstantAmount"},	
                    {"[Account L18 Id]","AccountL18"},
                    {"[Account (Leaf)]","AccountLeaf"},
                    {"[Scenario Descr]","Scenario"},	
                    {"[Source Sys Descr]","SourceSystem"},	
                    {"[Transaction Currency]","TransactionCurrency"},
                    {"[GOC]","[GOC]"}
            };

        #endregion

        public const string QueryMergeDate = "EXEC sp_ImportPearl";
        public const string QueryDeletePrevious = "DELETE FROM Pearl DELETE FROM PearlTemp";

        public const string QueryExcel = @"SELECT 
                            [Nat Sign Jan USD Amount],	
                            [Nat Sign Feb USD Amount],	
                            [Nat Sign Mar USD Amount],	
                            [Nat Sign Apr USD Amount],	
                            [Nat Sign May USD Amount],	
                            [Nat Sign Jun USD Amount],	
                            [Nat Sign Jul USD Amount],	
                            [Nat Sign Aug USD Amount],	
                            [Nat Sign Sep USD Amount],	
                            [Nat Sign Oct USD Amount],	
                            [Nat Sign Nov USD Amount],	
                            [Nat Sign Dec USD Amount],	
                            [Current Year Jan Constant Dollar Amount],	
                            [Current Year Feb Constant Dollar Amount],	
                            [Current Year Mar Constant Dollar Amount],	
                            [Current Year Apr Constant Dollar Amount],	
                            [Current Year May Constant Dollar Amount],	
                            [Current Year Jun Constant Dollar Amount],	
                            [Current Year Jul Constant Dollar Amount],	
                            [Current Year Aug Constant Dollar Amount],	
                            [Current Year Sep Constant Dollar Amount],	
                            [Current Year Oct Constant Dollar Amount],	
                            [Current Year Nov Constant Dollar Amount],	
                            [Current Year Dec Constant Dollar Amount],	
                            [Account (Leaf)],
                            [Account L18 Id],
                            [GOC],	
                            [Scenario Descr],	
                            [Source Sys Descr],	
                            [Transaction Currency]
                    FROM [{0}$]";
    }
}
